﻿using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class vp_Billing_PriceMapping : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        GridView1.DataSource = GetTable();
        GridView1.DataBind();
    }


    private DataTable GetTable()
    {

        DataTable dtbl1 = new DataTable();


        dtbl1.Columns.Add("Product Code", typeof(string));
        dtbl1.Columns.Add("Category Code", typeof(string));
        dtbl1.Columns.Add("User Type", typeof(string));
        dtbl1.Columns.Add("Price", typeof(int));
        dtbl1.Columns.Add("Discount", typeof(int));
      

        dtbl1.Rows.Add("Product01","Category01", "Agent", 100.00, 0.00);
        dtbl1.Rows.Add("Product01","Category02", "Reseller", 91.00, 05.00);
        dtbl1.Rows.Add("Product01","Category03", "User", 84.00, 02.00);
        
        return dtbl1;
    }
}
